Brasil DCI Frequency vs Severity
¶

Last update: 5/16/2024
Author: Abraham Guerrero J.

Description: This python code extract the information of DCI brasil, and clean it in a proper way.

shape: (11, 9)
coverageNúmeroPolizasNúmeroSiniestrosIncurridoTotalfrecuenciaseveridadPrimaTotalPrimaPuralossRatio
stri32i64f64f64f64f64f64f64
"THEFT"64,7142,21414,938,618.20.06,747.332,370,048.3160.2216.7
"WINDSTORM"94,9803,03439,081,967.40.012,881.329,820,150.6380.976.3
"FLOOD"8,8433106,853,157.20.022,107.02,901,650.9607.142.3
"ELECTRICAL DAMAGE"112,9106,05573,864,605.00.012,198.925,822,697.9604.035.0
"EQUIPMENT DAMAGE"4646440,120.8inf9,567.80.0inf0.0
"STRCC"55105,231.6inf21,046.30.0inf0.0
"WATER DAMAGE"58,1551,79814,539,993.10.08,086.812,175,569.3205.283.7
"FIRE"119,9812,05463,982,449.90.031,150.2111,817,092.8236.5174.8
"OTHER"101,2572,06612,686,436.60.06,140.626,883,443.651.9211.9
"GL"98,2831,58914,604,097.90.09,190.749,113,072.947.6336.3
"WORK DAMAGE"1700.00.0NaN18,886.6NaNinf
THEFT:

WINDSTORM:

FLOOD:

ELECTRICAL DAMAGE:

EQUIPMENT DAMAGE:

c:\Users\ABGUERR\AppData\Local\anaconda3\Lib\site-packages\holoviews\plotting\plot.py:1348: RuntimeWarning: invalid value encountered in scalar subtract
  yspan = y1-y0 if util.is_number(y0) and util.is_number(y1) else None
c:\Users\ABGUERR\AppData\Local\anaconda3\Lib\site-packages\holoviews\core\util.py:1069: RuntimeWarning: invalid value encountered in scalar subtract
  span = (upper-lower)
c:\Users\ABGUERR\AppData\Local\anaconda3\Lib\site-packages\holoviews\plotting\plot.py:1348: RuntimeWarning: invalid value encountered in scalar subtract
  yspan = y1-y0 if util.is_number(y0) and util.is_number(y1) else None
c:\Users\ABGUERR\AppData\Local\anaconda3\Lib\site-packages\holoviews\core\util.py:1069: RuntimeWarning: invalid value encountered in scalar subtract
  span = (upper-lower)
c:\Users\ABGUERR\AppData\Local\anaconda3\Lib\site-packages\holoviews\plotting\plot.py:1348: RuntimeWarning: invalid value encountered in scalar subtract
  yspan = y1-y0 if util.is_number(y0) and util.is_number(y1) else None
c:\Users\ABGUERR\AppData\Local\anaconda3\Lib\site-packages\holoviews\core\util.py:1069: RuntimeWarning: invalid value encountered in scalar subtract
  span = (upper-lower)
c:\Users\ABGUERR\AppData\Local\anaconda3\Lib\site-packages\holoviews\plotting\plot.py:1348: RuntimeWarning: invalid value encountered in scalar subtract
  yspan = y1-y0 if util.is_number(y0) and util.is_number(y1) else None
c:\Users\ABGUERR\AppData\Local\anaconda3\Lib\site-packages\holoviews\core\util.py:1069: RuntimeWarning: invalid value encountered in scalar subtract
  span = (upper-lower)
c:\Users\ABGUERR\AppData\Local\anaconda3\Lib\site-packages\holoviews\plotting\plot.py:1348: RuntimeWarning: invalid value encountered in scalar subtract
  yspan = y1-y0 if util.is_number(y0) and util.is_number(y1) else None
c:\Users\ABGUERR\AppData\Local\anaconda3\Lib\site-packages\holoviews\core\util.py:1069: RuntimeWarning: invalid value encountered in scalar subtract
  span = (upper-lower)
c:\Users\ABGUERR\AppData\Local\anaconda3\Lib\site-packages\holoviews\plotting\plot.py:1348: RuntimeWarning: invalid value encountered in scalar subtract
  yspan = y1-y0 if util.is_number(y0) and util.is_number(y1) else None
c:\Users\ABGUERR\AppData\Local\anaconda3\Lib\site-packages\holoviews\core\util.py:1069: RuntimeWarning: invalid value encountered in scalar subtract
  span = (upper-lower)
c:\Users\ABGUERR\AppData\Local\anaconda3\Lib\site-packages\holoviews\plotting\plot.py:1348: RuntimeWarning: invalid value encountered in scalar subtract
  yspan = y1-y0 if util.is_number(y0) and util.is_number(y1) else None
c:\Users\ABGUERR\AppData\Local\anaconda3\Lib\site-packages\holoviews\core\util.py:1069: RuntimeWarning: invalid value encountered in scalar subtract
  span = (upper-lower)
c:\Users\ABGUERR\AppData\Local\anaconda3\Lib\site-packages\holoviews\plotting\plot.py:1348: RuntimeWarning: invalid value encountered in scalar subtract
  yspan = y1-y0 if util.is_number(y0) and util.is_number(y1) else None
c:\Users\ABGUERR\AppData\Local\anaconda3\Lib\site-packages\holoviews\core\util.py:1069: RuntimeWarning: invalid value encountered in scalar subtract
  span = (upper-lower)
c:\Users\ABGUERR\AppData\Local\anaconda3\Lib\site-packages\holoviews\plotting\plot.py:1348: RuntimeWarning: invalid value encountered in scalar subtract
  yspan = y1-y0 if util.is_number(y0) and util.is_number(y1) else None
c:\Users\ABGUERR\AppData\Local\anaconda3\Lib\site-packages\holoviews\core\util.py:1069: RuntimeWarning: invalid value encountered in scalar subtract
  span = (upper-lower)
c:\Users\ABGUERR\AppData\Local\anaconda3\Lib\site-packages\holoviews\plotting\plot.py:1348: RuntimeWarning: invalid value encountered in scalar subtract
  yspan = y1-y0 if util.is_number(y0) and util.is_number(y1) else None
c:\Users\ABGUERR\AppData\Local\anaconda3\Lib\site-packages\holoviews\core\util.py:1069: RuntimeWarning: invalid value encountered in scalar subtract
  span = (upper-lower)
c:\Users\ABGUERR\AppData\Local\anaconda3\Lib\site-packages\holoviews\plotting\plot.py:1348: RuntimeWarning: invalid value encountered in scalar subtract
  yspan = y1-y0 if util.is_number(y0) and util.is_number(y1) else None
c:\Users\ABGUERR\AppData\Local\anaconda3\Lib\site-packages\holoviews\core\util.py:1069: RuntimeWarning: invalid value encountered in scalar subtract
  span = (upper-lower)
c:\Users\ABGUERR\AppData\Local\anaconda3\Lib\site-packages\holoviews\plotting\plot.py:1348: RuntimeWarning: invalid value encountered in scalar subtract
  yspan = y1-y0 if util.is_number(y0) and util.is_number(y1) else None
c:\Users\ABGUERR\AppData\Local\anaconda3\Lib\site-packages\holoviews\core\util.py:1069: RuntimeWarning: invalid value encountered in scalar subtract
  span = (upper-lower)
c:\Users\ABGUERR\AppData\Local\anaconda3\Lib\site-packages\holoviews\plotting\plot.py:1348: RuntimeWarning: invalid value encountered in scalar subtract
  yspan = y1-y0 if util.is_number(y0) and util.is_number(y1) else None
c:\Users\ABGUERR\AppData\Local\anaconda3\Lib\site-packages\holoviews\core\util.py:1069: RuntimeWarning: invalid value encountered in scalar subtract
  span = (upper-lower)
STRCC:

c:\Users\ABGUERR\AppData\Local\anaconda3\Lib\site-packages\holoviews\plotting\plot.py:1348: RuntimeWarning: invalid value encountered in scalar subtract
  yspan = y1-y0 if util.is_number(y0) and util.is_number(y1) else None
c:\Users\ABGUERR\AppData\Local\anaconda3\Lib\site-packages\holoviews\core\util.py:1069: RuntimeWarning: invalid value encountered in scalar subtract
  span = (upper-lower)
c:\Users\ABGUERR\AppData\Local\anaconda3\Lib\site-packages\holoviews\plotting\plot.py:1348: RuntimeWarning: invalid value encountered in scalar subtract
  yspan = y1-y0 if util.is_number(y0) and util.is_number(y1) else None
c:\Users\ABGUERR\AppData\Local\anaconda3\Lib\site-packages\holoviews\core\util.py:1069: RuntimeWarning: invalid value encountered in scalar subtract
  span = (upper-lower)
c:\Users\ABGUERR\AppData\Local\anaconda3\Lib\site-packages\holoviews\plotting\plot.py:1348: RuntimeWarning: invalid value encountered in scalar subtract
  yspan = y1-y0 if util.is_number(y0) and util.is_number(y1) else None
c:\Users\ABGUERR\AppData\Local\anaconda3\Lib\site-packages\holoviews\core\util.py:1069: RuntimeWarning: invalid value encountered in scalar subtract
  span = (upper-lower)
c:\Users\ABGUERR\AppData\Local\anaconda3\Lib\site-packages\holoviews\plotting\plot.py:1348: RuntimeWarning: invalid value encountered in scalar subtract
  yspan = y1-y0 if util.is_number(y0) and util.is_number(y1) else None
c:\Users\ABGUERR\AppData\Local\anaconda3\Lib\site-packages\holoviews\core\util.py:1069: RuntimeWarning: invalid value encountered in scalar subtract
  span = (upper-lower)
c:\Users\ABGUERR\AppData\Local\anaconda3\Lib\site-packages\holoviews\plotting\plot.py:1348: RuntimeWarning: invalid value encountered in scalar subtract
  yspan = y1-y0 if util.is_number(y0) and util.is_number(y1) else None
c:\Users\ABGUERR\AppData\Local\anaconda3\Lib\site-packages\holoviews\core\util.py:1069: RuntimeWarning: invalid value encountered in scalar subtract
  span = (upper-lower)
c:\Users\ABGUERR\AppData\Local\anaconda3\Lib\site-packages\holoviews\plotting\plot.py:1348: RuntimeWarning: invalid value encountered in scalar subtract
  yspan = y1-y0 if util.is_number(y0) and util.is_number(y1) else None
c:\Users\ABGUERR\AppData\Local\anaconda3\Lib\site-packages\holoviews\core\util.py:1069: RuntimeWarning: invalid value encountered in scalar subtract
  span = (upper-lower)
c:\Users\ABGUERR\AppData\Local\anaconda3\Lib\site-packages\holoviews\plotting\plot.py:1348: RuntimeWarning: invalid value encountered in scalar subtract
  yspan = y1-y0 if util.is_number(y0) and util.is_number(y1) else None
c:\Users\ABGUERR\AppData\Local\anaconda3\Lib\site-packages\holoviews\core\util.py:1069: RuntimeWarning: invalid value encountered in scalar subtract
  span = (upper-lower)
c:\Users\ABGUERR\AppData\Local\anaconda3\Lib\site-packages\holoviews\plotting\plot.py:1348: RuntimeWarning: invalid value encountered in scalar subtract
  yspan = y1-y0 if util.is_number(y0) and util.is_number(y1) else None
c:\Users\ABGUERR\AppData\Local\anaconda3\Lib\site-packages\holoviews\core\util.py:1069: RuntimeWarning: invalid value encountered in scalar subtract
  span = (upper-lower)
c:\Users\ABGUERR\AppData\Local\anaconda3\Lib\site-packages\holoviews\plotting\plot.py:1348: RuntimeWarning: invalid value encountered in scalar subtract
  yspan = y1-y0 if util.is_number(y0) and util.is_number(y1) else None
c:\Users\ABGUERR\AppData\Local\anaconda3\Lib\site-packages\holoviews\core\util.py:1069: RuntimeWarning: invalid value encountered in scalar subtract
  span = (upper-lower)
c:\Users\ABGUERR\AppData\Local\anaconda3\Lib\site-packages\holoviews\plotting\plot.py:1348: RuntimeWarning: invalid value encountered in scalar subtract
  yspan = y1-y0 if util.is_number(y0) and util.is_number(y1) else None
c:\Users\ABGUERR\AppData\Local\anaconda3\Lib\site-packages\holoviews\core\util.py:1069: RuntimeWarning: invalid value encountered in scalar subtract
  span = (upper-lower)
c:\Users\ABGUERR\AppData\Local\anaconda3\Lib\site-packages\holoviews\plotting\plot.py:1348: RuntimeWarning: invalid value encountered in scalar subtract
  yspan = y1-y0 if util.is_number(y0) and util.is_number(y1) else None
c:\Users\ABGUERR\AppData\Local\anaconda3\Lib\site-packages\holoviews\core\util.py:1069: RuntimeWarning: invalid value encountered in scalar subtract
  span = (upper-lower)
c:\Users\ABGUERR\AppData\Local\anaconda3\Lib\site-packages\holoviews\plotting\plot.py:1348: RuntimeWarning: invalid value encountered in scalar subtract
  yspan = y1-y0 if util.is_number(y0) and util.is_number(y1) else None
c:\Users\ABGUERR\AppData\Local\anaconda3\Lib\site-packages\holoviews\core\util.py:1069: RuntimeWarning: invalid value encountered in scalar subtract
  span = (upper-lower)
c:\Users\ABGUERR\AppData\Local\anaconda3\Lib\site-packages\holoviews\plotting\plot.py:1348: RuntimeWarning: invalid value encountered in scalar subtract
  yspan = y1-y0 if util.is_number(y0) and util.is_number(y1) else None
c:\Users\ABGUERR\AppData\Local\anaconda3\Lib\site-packages\holoviews\core\util.py:1069: RuntimeWarning: invalid value encountered in scalar subtract
  span = (upper-lower)
WATER DAMAGE:

FIRE:

OTHER:

GL:

WORK DAMAGE: